FO_Types_Container

This table requires a single record for each container code. Its purpose is to provide the associated relationships between a container, storage, and specimen. Container volume and aliquot container are also utilized during container management.

Create a container code called “NOLABEL” which is applied to orderable test codes that do not require a label to print. “NOLABEL” is specifically recognized by the FAST system.

 

Field Type Notes

Container_ID

numeric(18, 0)

ID field, a counter. Unique

SourceSystem

varchar(500)

Future use.

Code

varchar(20)

Enter a unique container code.

Name

varchar(50)

Description of container code.

GroupCodes

varchar(255)

Enter a valid container group code.

Containers with like group codes can be combined together in determining container ID.

StorageCode

varchar(255)

Represents a list of acceptable storage temperatures, as storage codes, for the container code.

Multidimensional pipe delimited field, with leading and trailing pipes.

Enter valid storage codes separated by pipes; codes as defined in the FO_Types_Storage table.

IE: |StorageCode1|StorageCode2|StorageCode3|

SpecimenCode

varchar(255)

Represents a list of acceptable specimen codes for the container code.

Multidimensional pipe delimited field, with leading and trailing pipes.

Enter valid specimen codes separated by pipes; codes as defined in the FO_Types_Specimen table.

IE: |SpecimenCode1|SpecimenCode2|SpecimenCode3|

ContainerVolume

numeric(18, 0)

Maximum volume allowed for container before a new container ID should be generated.

Enter an integer for the maximum volume.

AliquoteContainerCodes

varchar(255)

Represents a list of acceptable aliquot container codes for the container code.

Multidimensional pipe delimited field, with leading and trailing pipes.

Enter valid aliquot container codes separated by pipes; codes as defined in the FO_Types_Container table.

IE: |ContainerCode1|ContainerCode2|ContainerCode3|

LabelFormatID

varchar(50)

Future use.

LabelSequence

varchar(50)

Enter a string to control the label sequence for the container type printed on labels.

Use the same number of characters in all records so alphanumeric sequencing is effective.

CreateDate

datetime

Date record was created.

Informational

CreateUser

varchar(50)

User who created record.

Informational

EditDate

datetime

Date record was last edited.

Informational

EditUser

varchar(50)

User who last edited record.

Informational